SELECT
	Contact.FirstName,
	Contact.LastName,
	Product.Name, 
	SalesOrderDetail.OrderQty,
	SalesOrderDetail.UnitPrice,
	SpecialOffer.Category,
	SalesOrderHeader.OrderDate
FROM         
	Sales.SalesOrderHeader 
	INNER JOIN 
	Sales.SalesOrderDetail 
		ON Sales.SalesOrderDetail.SalesOrderID = Sales.SalesOrderHeader.SalesOrderID 
	INNER JOIN
	Sales.SpecialOfferProduct 
		ON Sales.SalesOrderDetail.SpecialOfferID = Sales.SpecialOfferProduct.SpecialOfferID 
			AND Sales.SalesOrderDetail.ProductID = Sales.SpecialOfferProduct.ProductID 
	INNER JOIN
	Sales.SpecialOffer 
		ON Sales.SpecialOfferProduct.SpecialOfferID = Sales.SpecialOffer.SpecialOfferID 
	INNER JOIN
	Production.Product 
		ON Sales.SpecialOfferProduct.ProductID = Production.Product.ProductID
	LEFT OUTER JOIN
	Sales.Individual 
		ON Sales.SalesOrderHeader.CustomerID = Sales.Individual.CustomerID 
	LEFT OUTER JOIN
	Person.Contact 
		ON Sales.Individual.ContactID = Person.Contact.ContactID	
WHERE 
	Product.Name LIKE 'Mountain%'
	AND 
	Contact.FirstName LIKE 'P%'
	AND 
	SalesOrderHeader.OrderDate BETWEEN '2003-01-01' AND '2004-07-07'
ORDER BY
	Contact.FirstName,
	Contact.LastName,
	Product.Name